﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Pages/MenuManagement/TEST/Site1.Master" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="RestaurantManagerWebApp.Pages.MenuManagement.TEST.WebForm1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .auto-style1 {
            text-align: left;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
   
    &nbsp;<div id="container-5">
            <ul>

                <li class="auto-style1"><a href="#fragment-1"><span>Food Menu (Ala Carte)</span></a></li>
                <li class="auto-style1"><a href="#fragment-2"><span>Set Meals</span></a></li>
                <li class="auto-style1"><a href="#fragment-3"><span>Orders</span></a></li>
                <li class="auto-style1"><a href="#fragment-4"><span>Administrator</span></a></li>
            </ul>
           
            
            <div id="fragment-1">
                <div class="auto-style1">
                This will display the Ala carte food Menu
                </div>
                <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="d_name" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None">
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    <Columns>
                        <asp:BoundField DataField="c_id" HeaderText="ID" SortExpression="c_id" />
                        <asp:BoundField DataField="d_name" HeaderText="Name" ReadOnly="True" SortExpression="d_name" />
                        <asp:BoundField DataField="status" HeaderText="status" SortExpression="status" />
                        <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
                        <asp:BoundField DataField="description" HeaderText="description" SortExpression="description" />
                        <asp:BoundField DataField="comments" HeaderText="comments" SortExpression="comments" />
                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                        <asp:BoundField DataField="image" HeaderText="image" SortExpression="image" />
                    </Columns>
                    <EditRowStyle BackColor="#999999" />
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                    <SortedAscendingCellStyle BackColor="#E9E7E2" />
                    <SortedAscendingHeaderStyle BackColor="#506C8C" />
                    <SortedDescendingCellStyle BackColor="#FFFDF8" />
                    <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                </asp:GridView>
                <asp:Button ID="Button1" runat="server" style="text-align: left" Text="Order" />
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Dish]">
                </asp:SqlDataSource>
                
            </div> 
            <%--End of first Tab--%>

            <div id="fragment-2">
                <p class="auto-style1">This will display the SET food Menu</p>
                <p>
                    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="s_name,d_name" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None">
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        <Columns>
                            <asp:BoundField DataField="s_name" HeaderText="s_name" ReadOnly="True" SortExpression="s_name" />
                            <asp:BoundField DataField="d_name" HeaderText="d_name" ReadOnly="True" SortExpression="d_name" />
                            <asp:BoundField DataField="quantity" HeaderText="quantity" SortExpression="quantity" />
                            <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" />
                        </Columns>
                        <EditRowStyle BackColor="#999999" />
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <SortedAscendingCellStyle BackColor="#E9E7E2" />
                        <SortedAscendingHeaderStyle BackColor="#506C8C" />
                        <SortedDescendingCellStyle BackColor="#FFFDF8" />
                        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [SetMeal] WHERE [s_name] = @s_name AND [d_name] = @d_name" InsertCommand="INSERT INTO [SetMeal] ([s_name], [d_name], [quantity], [price]) VALUES (@s_name, @d_name, @quantity, @price)" SelectCommand="SELECT * FROM [SetMeal]" UpdateCommand="UPDATE [SetMeal] SET [quantity] = @quantity, [price] = @price WHERE [s_name] = @s_name AND [d_name] = @d_name">
                        <DeleteParameters>
                            <asp:Parameter Name="s_name" Type="String" />
                            <asp:Parameter Name="d_name" Type="String" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="s_name" Type="String" />
                            <asp:Parameter Name="d_name" Type="String" />
                            <asp:Parameter Name="quantity" Type="Decimal" />
                            <asp:Parameter Name="price" Type="Decimal" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="quantity" Type="Decimal" />
                            <asp:Parameter Name="price" Type="Decimal" />
                            <asp:Parameter Name="s_name" Type="String" />
                            <asp:Parameter Name="d_name" Type="String" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </p>
            </div>

        <%--START of TAB 3--%>
            <div id="fragment-3">
             <p class="auto-style1">Orders</p>
                Orders will be here, check out function
               
             </div>

        <%--START of TAB 4--%>
        <div id="fragment-4">
         <p class="auto-style1">Administrator</p>
         admin to add/ edit delete 
                
             </div>

 </div>
        <script type="text/javascript">
            $(function () {
                $('#container-5').tabs({ fxSlide: true, fxFade: true, fxSpeed: 'normal' });
            });
        </script>
   
</asp:Content>
